package htlgkr.nodlehs;

public class DBRefSubTeaTbl implements DBRefSubTeaColumns{
	public static final String TABLE_NAME = "subtea";
	public static final String SQL_DROP = "DROP TABLE IF EXISTS subtea";
	public static final String SQL_DEL = "DELETE subtea";
	public static final String[] ALL_COLUMNS = new String[] { t_ID + " AS _id", s_ID};
	public static final String SQL_CREATE = "CREATE TABLE subtea ( " +
			"t_ID INTEGER NOT NULL, " +
			"s_ID INTEGER NOT NULL, " +
			"PRIMARY KEY(t_ID, s_ID), " +
			"FOREIGN KEY(t_ID) REFERENCES teachers(tea_ID), " +
			"FOREIGN KEY(s_ID) REFERENCES subjects(sub_ID))";
	public static final String SQL_INSERT = "INSERT INTO subtea (t_ID, s_ID) VALUES(?,?)";
}
